3 visuals for webpage

This code will help produce the three visuals that are going to be a part of each equity tracker indicator webpage: regional map (tract level) of most recent data, chart of the most recent data, chart of trends over time.

If the indicator is available through a tract-level data set. Getting the data to a workable version may require some data transformation. To explore, clean, transform, and generate a final data set, please use the data-gen-tract-template. This script will generate an .rda for the map and an .rda for the charts. These data sets will be loaded in before the data visualization code.

Indicator Explanation

Measuring the proportion of sidewalks along an arterial segment gives us an idea of the completeness of pedestrian infrastructure on major travel corridors in the region. Differences between groups of people can highlight differing access to safe infrastructure. For this indicator, we are measuring sidewalk completeness as the percent of partial or complete sidewalks along the total length of arterial segments within a given census tract.

1. Map of most recent data

To map data in this form, there should be a value corresponding to each census tract. Depending on the year or source of the data, this could be about 700 rows for data at the 2010 census tract resolution, or about 900 rows for data at the 2020 census tract resolution.

Create Visual

Source(s): Puget Sound Regional Council, Regional Bicycle and Pedestrian Facilities, 2022; U.S. Census Bureau, Geography Division 2020 TIGER/Line Shapefiles



Data call outs

  1. 49%: The share of arterial road segments in the region with partial or complete sidewalks
  2. 31%: The share of tracts where all arterial segments have partial or complete sidewalks
  3. 5%: The share of tracts where all arterial segments have no sidewalks


Insights & Analysis

  • King County has the highest percent of sidewalk completeness (73%), followed by Snohomish (51%), Pierce (41%), and Kitsap (26%)
  • Half of all census tracts in the region have a sidewalk completeness share of 88% or greater
  • Each county in the region has tracts with 100% sidewalk completeness and tracts with 0% sidewalk completeness



2. Facet of most recent data

Create Visual

Sidewalk Completeness by Community

Percent of arterial road segments with partial or complete sidewalks

Data call outs

  1. 83%: The share of sidewalk completeness for census tracts in the region with the highest concentration of limited English proficient households, compared to 38% in census tracts with the lowest concentration of limited English proficient households
  2. 5%: The lowest share of sidewalk completeness across categories, found in Kitsap County tracts with the lowest proportion of limited English proficient households
  3. 28%: The share of sidewalk completeness for tracts in Pierce County with the highest concentration of people with disabilities


Insights & Analysis

  • Census tracts in the region with the highest concentration of people of color have more than three times the proportion of sidewalk completeness along arterials than tracts with the lowest concentration of people of color (80% vs. 25%).
  • The highest proportion of sidewalk completeness (96%) is found in King County tracts with the lowest concentration of households with youth. Tracts in King County with the highest concentration of households with youth have a share of only 59%.
  • For the region as a whole, tracts with the highest concentration of people of color, low income households, and limited English proficient households have higher proportions of sidewalk completeness than tracts with the lowest concentration of those groups. For tracts with the highest concentration of people with disabilities and households with older adults, the opposite is true.



Transfer files

Copy files from Github > Y drive

Copy files from Y drive > website folder

Back to top of the page